using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using DaoHelper.Religion.Entity;
using DaoHelper.Religion.Entity.Helper;

namespace DaoHelper.Religion
{
	public class AspnetUsersDao : AspnetUsersDaoBase
	{
		/// <summary>
		/// Purpose: Class constructor.
		/// </summary>
		public static AspnetUsersDao Instants()
		{
			return new AspnetUsersDao();
		}

        public DataTable GetAll()
        {
            string strSQL = @"Select u.UserId, UserName, LastLoginDate
                            From aspnet_Users u INNER JOIN aspnet_Membership m ON u.UserId=m.UserId
                            Order By UserName";
            return ExecuteDataTable(CommandType.Text, strSQL);
        }
	}
}
